package com.chenyue.cm.user.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.chenyue.cm.user.domain.JdGoodsSku;
import com.chenyue.cm.base.dao.LcBaseMapper;

import java.math.BigDecimal;

/**
* JdGoodsSkuMapper
*
* @author chenyue-cm
* @copy chenyue-cm-codemaker
* @date 2024-03-01
*/
@Mapper
@Repository("jdGoodsSkuMapper")
public interface JdGoodsSkuMapper extends LcBaseMapper<JdGoodsSku, String> ,BaseMapper<JdGoodsSku> {


    @Select("select min(sku_saleprice) from jd_goods_sku where goods_id = #{goodsId}")
    BigDecimal getSkuMinPriceByGoodsId(String goodsId);

}
